﻿using HabboEnvironment_R3.Kernel.Storage;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace habbo.Kernel.Storage.Querys
{
    class SelectAllCatalogPages : Query
    {
        public SelectAllCatalogPages()
        {
            base.Listen("SELECT * FROM catalog_pages WHERE parent_id = -1 ORDER BY order_num" , QueryType.DataTable);
        }
    }

    class GetSubCategories : Query
    {
        public GetSubCategories(int PageId)
        {
            base.Listen("SELECT * FROM catalog_pages WHERE parent_id = @pageid ORDER BY order_num", QueryType.DataTable);
            base.Push("pageid", PageId);
        }
    }
}
